SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROC [dbo].[usp_TraCuuThanhVien]
	@MaTV CHAR(12)
AS
BEGIN
	SELECT MATV, MAT_KHAU, HO_TEN, GIOI_TINH, NGAYSINH, DIA_CHI, NGHE_NGHIEP, CMND, HO_CHIEU, EMAIL, DIEN_THOAI_1, DIEN_THOAI_2, DIEM_TICH_LUY, LOAITV, QUOC_TICH
	FROM THANH_VIEN
	WHERE  MATV = @MaTV
END

GO
